ExternalTenderDepositorySettlementTenderDetail

Entity Definition

Logical Name : ExternalTenderDepositorySettlementTenderDetail
Physical Name : LE_TND_DSY_STLM_TND_HSTRY

An EXTERNAL DEPOSITORY-level accumulation of tender in and outflows for an external depository settlement period along with opening, closing and variance values. An external depository settlement period is bounded by two consecutive ExternalDepositorySettlementTransactions.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) ExternalDepositoryDocument(LE_HST_EXTDST)
TenderRepositoryID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer ExternalDepositoryDocument(LE_HST_EXTDST)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type TY_TND Code varchar(20) Tender(AS_TND)
OpenBalanceAmount The opening tender balance in the EXTERNAL TENDER DEPOSITORY for an external depositoryl settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. MO_OPN_BLNC_AMT Money decimal(16,5)
OpenMediaUnitQuantity The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. QU_OPN_MD_UN QuantityInteger integer
CloseBalanceAmount The closing tender balance in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. The closing balance represents the system's total. MO_CL_BLNC_AMT Money decimal(16,5)
CloseMediaUnitQuantity The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. QU_CL_MD_UN QuantityInteger integer
CountedBalanceAmount The counted tender balance in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of an external depository settlement period. MO_CNT_BLNC_AMT Money decimal(16,5)
CountedMediaUnitQuantity The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the EXTERNAL TENDER REPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. QU_CNT_MD_UN QuantityInteger integer
OverUnderBalanceAmount The variance between closing balance amount and counted balance amount at the end of an external depository settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) MO_OVR_UND_BLNC_AMT Money decimal(16,5)
OverUnderMediaUnitQuantity The variance between closing media unit quantity and counted media unit quantity at the end of an external depository settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) QU_OVR_UND_MD_UN QuantityInteger integer
DepositFromSafeAmount The sum of deposits made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period. This is money moving from the store safe into the bank. MO_DS_FRM_SF_AMT Money decimal(16,5)
DepositFromSafeMediaUnitQuantity The sum of tender media unit quantities made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period. This is money moving from the store safe into the bank. QU_DS_FRM_SF_MD_UN QuantityInteger integer
ReceiptToSafeAmount The sum of tender withdrawn from this external depository (bank) and received into store safes for an external depository settlement period. This represents tender pulled out from a bank and received into a safe for use in making change. MO_RCPT_TO_SF_AMT Money decimal(16,5)
ReceiptToSafeMediaUnitQuantity The sum of tender media unit quantities withdrawn from this external depository (bank) and received into store safes for an external depository settlement period. This represents tender pulled out from a bank and received into a safe for use in making change. QU_RCPT_TO_SF_MD_UN QuantityInteger integer

Relationships

Parent Entity Verb Phrase Child Entity
Tender classifies ExternalTenderDepositorySettlementTenderDetail
ExternalDepositoryDocument is composed of ExternalTenderDepositorySettlementTenderDetail

Logical Views containing ExternalTenderDepositorySettlementTenderDetail

Logical View
Logical 02400 - Control Transaction Macro View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03110 - Reporting - Store Operations - Tender Settlement
Logical 03160 - Reporting - Store Operations - Till View